package com.jell.purchase.model.Query;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderInfoQuery {
    /**
     * crm_order_info
     */
    protected String orderByClause;

    /**
     * crm_order_info
     */
    protected boolean distinct;

    /**
     * crm_order_info
     */
    protected List<Criteria> oredCriteria;

    /**
     * crm_order_info
     */
    public OrderInfoQuery() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * crm_order_info
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * crm_order_info
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * crm_order_info
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * crm_order_info
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * crm_order_info
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * crm_order_info
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * crm_order_info
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * crm_order_info
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * crm_order_info
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * crm_order_info
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class corresponds to the database table crm_order_info
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andRecipientNameIsNull() {
            addCriterion("recipient_name is null");
            return (Criteria) this;
        }

        public Criteria andRecipientNameIsNotNull() {
            addCriterion("recipient_name is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientNameEqualTo(String value) {
            addCriterion("recipient_name =", value, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameNotEqualTo(String value) {
            addCriterion("recipient_name <>", value, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameGreaterThan(String value) {
            addCriterion("recipient_name >", value, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameGreaterThanOrEqualTo(String value) {
            addCriterion("recipient_name >=", value, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameLessThan(String value) {
            addCriterion("recipient_name <", value, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameLessThanOrEqualTo(String value) {
            addCriterion("recipient_name <=", value, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameLike(String value) {
            addCriterion("recipient_name like", value, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameNotLike(String value) {
            addCriterion("recipient_name not like", value, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameIn(List<String> values) {
            addCriterion("recipient_name in", values, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameNotIn(List<String> values) {
            addCriterion("recipient_name not in", values, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameBetween(String value1, String value2) {
            addCriterion("recipient_name between", value1, value2, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientNameNotBetween(String value1, String value2) {
            addCriterion("recipient_name not between", value1, value2, "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneIsNull() {
            addCriterion("recipient_phone is null");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneIsNotNull() {
            addCriterion("recipient_phone is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneEqualTo(String value) {
            addCriterion("recipient_phone =", value, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneNotEqualTo(String value) {
            addCriterion("recipient_phone <>", value, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneGreaterThan(String value) {
            addCriterion("recipient_phone >", value, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("recipient_phone >=", value, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneLessThan(String value) {
            addCriterion("recipient_phone <", value, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneLessThanOrEqualTo(String value) {
            addCriterion("recipient_phone <=", value, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneLike(String value) {
            addCriterion("recipient_phone like", value, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneNotLike(String value) {
            addCriterion("recipient_phone not like", value, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneIn(List<String> values) {
            addCriterion("recipient_phone in", values, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneNotIn(List<String> values) {
            addCriterion("recipient_phone not in", values, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneBetween(String value1, String value2) {
            addCriterion("recipient_phone between", value1, value2, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneNotBetween(String value1, String value2) {
            addCriterion("recipient_phone not between", value1, value2, "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailIsNull() {
            addCriterion("recipient_email is null");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailIsNotNull() {
            addCriterion("recipient_email is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailEqualTo(String value) {
            addCriterion("recipient_email =", value, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailNotEqualTo(String value) {
            addCriterion("recipient_email <>", value, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailGreaterThan(String value) {
            addCriterion("recipient_email >", value, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailGreaterThanOrEqualTo(String value) {
            addCriterion("recipient_email >=", value, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailLessThan(String value) {
            addCriterion("recipient_email <", value, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailLessThanOrEqualTo(String value) {
            addCriterion("recipient_email <=", value, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailLike(String value) {
            addCriterion("recipient_email like", value, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailNotLike(String value) {
            addCriterion("recipient_email not like", value, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailIn(List<String> values) {
            addCriterion("recipient_email in", values, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailNotIn(List<String> values) {
            addCriterion("recipient_email not in", values, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailBetween(String value1, String value2) {
            addCriterion("recipient_email between", value1, value2, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailNotBetween(String value1, String value2) {
            addCriterion("recipient_email not between", value1, value2, "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeIsNull() {
            addCriterion("recipient_zipcode is null");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeIsNotNull() {
            addCriterion("recipient_zipcode is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeEqualTo(String value) {
            addCriterion("recipient_zipcode =", value, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeNotEqualTo(String value) {
            addCriterion("recipient_zipcode <>", value, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeGreaterThan(String value) {
            addCriterion("recipient_zipcode >", value, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeGreaterThanOrEqualTo(String value) {
            addCriterion("recipient_zipcode >=", value, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeLessThan(String value) {
            addCriterion("recipient_zipcode <", value, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeLessThanOrEqualTo(String value) {
            addCriterion("recipient_zipcode <=", value, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeLike(String value) {
            addCriterion("recipient_zipcode like", value, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeNotLike(String value) {
            addCriterion("recipient_zipcode not like", value, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeIn(List<String> values) {
            addCriterion("recipient_zipcode in", values, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeNotIn(List<String> values) {
            addCriterion("recipient_zipcode not in", values, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeBetween(String value1, String value2) {
            addCriterion("recipient_zipcode between", value1, value2, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeNotBetween(String value1, String value2) {
            addCriterion("recipient_zipcode not between", value1, value2, "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdIsNull() {
            addCriterion("recipient_country_id is null");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdIsNotNull() {
            addCriterion("recipient_country_id is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdEqualTo(Integer value) {
            addCriterion("recipient_country_id =", value, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdNotEqualTo(Integer value) {
            addCriterion("recipient_country_id <>", value, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdGreaterThan(Integer value) {
            addCriterion("recipient_country_id >", value, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("recipient_country_id >=", value, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdLessThan(Integer value) {
            addCriterion("recipient_country_id <", value, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdLessThanOrEqualTo(Integer value) {
            addCriterion("recipient_country_id <=", value, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdIn(List<Integer> values) {
            addCriterion("recipient_country_id in", values, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdNotIn(List<Integer> values) {
            addCriterion("recipient_country_id not in", values, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdBetween(Integer value1, Integer value2) {
            addCriterion("recipient_country_id between", value1, value2, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientCountryIdNotBetween(Integer value1, Integer value2) {
            addCriterion("recipient_country_id not between", value1, value2, "recipientCountryId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdIsNull() {
            addCriterion("recipient_region_id is null");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdIsNotNull() {
            addCriterion("recipient_region_id is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdEqualTo(Integer value) {
            addCriterion("recipient_region_id =", value, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdNotEqualTo(Integer value) {
            addCriterion("recipient_region_id <>", value, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdGreaterThan(Integer value) {
            addCriterion("recipient_region_id >", value, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("recipient_region_id >=", value, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdLessThan(Integer value) {
            addCriterion("recipient_region_id <", value, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdLessThanOrEqualTo(Integer value) {
            addCriterion("recipient_region_id <=", value, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdIn(List<Integer> values) {
            addCriterion("recipient_region_id in", values, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdNotIn(List<Integer> values) {
            addCriterion("recipient_region_id not in", values, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdBetween(Integer value1, Integer value2) {
            addCriterion("recipient_region_id between", value1, value2, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionIdNotBetween(Integer value1, Integer value2) {
            addCriterion("recipient_region_id not between", value1, value2, "recipientRegionId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdIsNull() {
            addCriterion("recipient_city_id is null");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdIsNotNull() {
            addCriterion("recipient_city_id is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdEqualTo(Integer value) {
            addCriterion("recipient_city_id =", value, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdNotEqualTo(Integer value) {
            addCriterion("recipient_city_id <>", value, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdGreaterThan(Integer value) {
            addCriterion("recipient_city_id >", value, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("recipient_city_id >=", value, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdLessThan(Integer value) {
            addCriterion("recipient_city_id <", value, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdLessThanOrEqualTo(Integer value) {
            addCriterion("recipient_city_id <=", value, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdIn(List<Integer> values) {
            addCriterion("recipient_city_id in", values, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdNotIn(List<Integer> values) {
            addCriterion("recipient_city_id not in", values, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdBetween(Integer value1, Integer value2) {
            addCriterion("recipient_city_id between", value1, value2, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientCityIdNotBetween(Integer value1, Integer value2) {
            addCriterion("recipient_city_id not between", value1, value2, "recipientCityId");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1IsNull() {
            addCriterion("recipient_address1 is null");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1IsNotNull() {
            addCriterion("recipient_address1 is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1EqualTo(String value) {
            addCriterion("recipient_address1 =", value, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1NotEqualTo(String value) {
            addCriterion("recipient_address1 <>", value, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1GreaterThan(String value) {
            addCriterion("recipient_address1 >", value, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1GreaterThanOrEqualTo(String value) {
            addCriterion("recipient_address1 >=", value, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1LessThan(String value) {
            addCriterion("recipient_address1 <", value, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1LessThanOrEqualTo(String value) {
            addCriterion("recipient_address1 <=", value, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1Like(String value) {
            addCriterion("recipient_address1 like", value, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1NotLike(String value) {
            addCriterion("recipient_address1 not like", value, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1In(List<String> values) {
            addCriterion("recipient_address1 in", values, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1NotIn(List<String> values) {
            addCriterion("recipient_address1 not in", values, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1Between(String value1, String value2) {
            addCriterion("recipient_address1 between", value1, value2, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1NotBetween(String value1, String value2) {
            addCriterion("recipient_address1 not between", value1, value2, "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2IsNull() {
            addCriterion("recipient_address2 is null");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2IsNotNull() {
            addCriterion("recipient_address2 is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2EqualTo(String value) {
            addCriterion("recipient_address2 =", value, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2NotEqualTo(String value) {
            addCriterion("recipient_address2 <>", value, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2GreaterThan(String value) {
            addCriterion("recipient_address2 >", value, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2GreaterThanOrEqualTo(String value) {
            addCriterion("recipient_address2 >=", value, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2LessThan(String value) {
            addCriterion("recipient_address2 <", value, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2LessThanOrEqualTo(String value) {
            addCriterion("recipient_address2 <=", value, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2Like(String value) {
            addCriterion("recipient_address2 like", value, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2NotLike(String value) {
            addCriterion("recipient_address2 not like", value, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2In(List<String> values) {
            addCriterion("recipient_address2 in", values, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2NotIn(List<String> values) {
            addCriterion("recipient_address2 not in", values, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2Between(String value1, String value2) {
            addCriterion("recipient_address2 between", value1, value2, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2NotBetween(String value1, String value2) {
            addCriterion("recipient_address2 not between", value1, value2, "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdIsNull() {
            addCriterion("delivery_way_id is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdIsNotNull() {
            addCriterion("delivery_way_id is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdEqualTo(Integer value) {
            addCriterion("delivery_way_id =", value, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdNotEqualTo(Integer value) {
            addCriterion("delivery_way_id <>", value, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdGreaterThan(Integer value) {
            addCriterion("delivery_way_id >", value, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("delivery_way_id >=", value, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdLessThan(Integer value) {
            addCriterion("delivery_way_id <", value, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdLessThanOrEqualTo(Integer value) {
            addCriterion("delivery_way_id <=", value, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdIn(List<Integer> values) {
            addCriterion("delivery_way_id in", values, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdNotIn(List<Integer> values) {
            addCriterion("delivery_way_id not in", values, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdBetween(Integer value1, Integer value2) {
            addCriterion("delivery_way_id between", value1, value2, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryWayIdNotBetween(Integer value1, Integer value2) {
            addCriterion("delivery_way_id not between", value1, value2, "deliveryWayId");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeIsNull() {
            addCriterion("delivery_code is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeIsNotNull() {
            addCriterion("delivery_code is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeEqualTo(String value) {
            addCriterion("delivery_code =", value, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeNotEqualTo(String value) {
            addCriterion("delivery_code <>", value, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeGreaterThan(String value) {
            addCriterion("delivery_code >", value, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_code >=", value, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeLessThan(String value) {
            addCriterion("delivery_code <", value, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeLessThanOrEqualTo(String value) {
            addCriterion("delivery_code <=", value, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeLike(String value) {
            addCriterion("delivery_code like", value, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeNotLike(String value) {
            addCriterion("delivery_code not like", value, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeIn(List<String> values) {
            addCriterion("delivery_code in", values, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeNotIn(List<String> values) {
            addCriterion("delivery_code not in", values, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeBetween(String value1, String value2) {
            addCriterion("delivery_code between", value1, value2, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeNotBetween(String value1, String value2) {
            addCriterion("delivery_code not between", value1, value2, "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullIsNull() {
            addCriterion("delivery_code_full is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullIsNotNull() {
            addCriterion("delivery_code_full is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullEqualTo(String value) {
            addCriterion("delivery_code_full =", value, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullNotEqualTo(String value) {
            addCriterion("delivery_code_full <>", value, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullGreaterThan(String value) {
            addCriterion("delivery_code_full >", value, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_code_full >=", value, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullLessThan(String value) {
            addCriterion("delivery_code_full <", value, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullLessThanOrEqualTo(String value) {
            addCriterion("delivery_code_full <=", value, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullLike(String value) {
            addCriterion("delivery_code_full like", value, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullNotLike(String value) {
            addCriterion("delivery_code_full not like", value, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullIn(List<String> values) {
            addCriterion("delivery_code_full in", values, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullNotIn(List<String> values) {
            addCriterion("delivery_code_full not in", values, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullBetween(String value1, String value2) {
            addCriterion("delivery_code_full between", value1, value2, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullNotBetween(String value1, String value2) {
            addCriterion("delivery_code_full not between", value1, value2, "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthIsNull() {
            addCriterion("delivery_length is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthIsNotNull() {
            addCriterion("delivery_length is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthEqualTo(Double value) {
            addCriterion("delivery_length =", value, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthNotEqualTo(Double value) {
            addCriterion("delivery_length <>", value, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthGreaterThan(Double value) {
            addCriterion("delivery_length >", value, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthGreaterThanOrEqualTo(Double value) {
            addCriterion("delivery_length >=", value, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthLessThan(Double value) {
            addCriterion("delivery_length <", value, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthLessThanOrEqualTo(Double value) {
            addCriterion("delivery_length <=", value, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthIn(List<Double> values) {
            addCriterion("delivery_length in", values, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthNotIn(List<Double> values) {
            addCriterion("delivery_length not in", values, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthBetween(Double value1, Double value2) {
            addCriterion("delivery_length between", value1, value2, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryLengthNotBetween(Double value1, Double value2) {
            addCriterion("delivery_length not between", value1, value2, "deliveryLength");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthIsNull() {
            addCriterion("delivery_width is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthIsNotNull() {
            addCriterion("delivery_width is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthEqualTo(Double value) {
            addCriterion("delivery_width =", value, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthNotEqualTo(Double value) {
            addCriterion("delivery_width <>", value, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthGreaterThan(Double value) {
            addCriterion("delivery_width >", value, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthGreaterThanOrEqualTo(Double value) {
            addCriterion("delivery_width >=", value, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthLessThan(Double value) {
            addCriterion("delivery_width <", value, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthLessThanOrEqualTo(Double value) {
            addCriterion("delivery_width <=", value, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthIn(List<Double> values) {
            addCriterion("delivery_width in", values, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthNotIn(List<Double> values) {
            addCriterion("delivery_width not in", values, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthBetween(Double value1, Double value2) {
            addCriterion("delivery_width between", value1, value2, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryWidthNotBetween(Double value1, Double value2) {
            addCriterion("delivery_width not between", value1, value2, "deliveryWidth");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightIsNull() {
            addCriterion("delivery_height is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightIsNotNull() {
            addCriterion("delivery_height is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightEqualTo(Double value) {
            addCriterion("delivery_height =", value, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightNotEqualTo(Double value) {
            addCriterion("delivery_height <>", value, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightGreaterThan(Double value) {
            addCriterion("delivery_height >", value, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightGreaterThanOrEqualTo(Double value) {
            addCriterion("delivery_height >=", value, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightLessThan(Double value) {
            addCriterion("delivery_height <", value, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightLessThanOrEqualTo(Double value) {
            addCriterion("delivery_height <=", value, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightIn(List<Double> values) {
            addCriterion("delivery_height in", values, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightNotIn(List<Double> values) {
            addCriterion("delivery_height not in", values, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightBetween(Double value1, Double value2) {
            addCriterion("delivery_height between", value1, value2, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryHeightNotBetween(Double value1, Double value2) {
            addCriterion("delivery_height not between", value1, value2, "deliveryHeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightIsNull() {
            addCriterion("delivery_weight is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightIsNotNull() {
            addCriterion("delivery_weight is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightEqualTo(Double value) {
            addCriterion("delivery_weight =", value, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightNotEqualTo(Double value) {
            addCriterion("delivery_weight <>", value, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightGreaterThan(Double value) {
            addCriterion("delivery_weight >", value, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightGreaterThanOrEqualTo(Double value) {
            addCriterion("delivery_weight >=", value, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightLessThan(Double value) {
            addCriterion("delivery_weight <", value, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightLessThanOrEqualTo(Double value) {
            addCriterion("delivery_weight <=", value, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightIn(List<Double> values) {
            addCriterion("delivery_weight in", values, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightNotIn(List<Double> values) {
            addCriterion("delivery_weight not in", values, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightBetween(Double value1, Double value2) {
            addCriterion("delivery_weight between", value1, value2, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryWeightNotBetween(Double value1, Double value2) {
            addCriterion("delivery_weight not between", value1, value2, "deliveryWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightIsNull() {
            addCriterion("delivery_volume_weight is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightIsNotNull() {
            addCriterion("delivery_volume_weight is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightEqualTo(Double value) {
            addCriterion("delivery_volume_weight =", value, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightNotEqualTo(Double value) {
            addCriterion("delivery_volume_weight <>", value, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightGreaterThan(Double value) {
            addCriterion("delivery_volume_weight >", value, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightGreaterThanOrEqualTo(Double value) {
            addCriterion("delivery_volume_weight >=", value, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightLessThan(Double value) {
            addCriterion("delivery_volume_weight <", value, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightLessThanOrEqualTo(Double value) {
            addCriterion("delivery_volume_weight <=", value, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightIn(List<Double> values) {
            addCriterion("delivery_volume_weight in", values, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightNotIn(List<Double> values) {
            addCriterion("delivery_volume_weight not in", values, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightBetween(Double value1, Double value2) {
            addCriterion("delivery_volume_weight between", value1, value2, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andDeliveryVolumeWeightNotBetween(Double value1, Double value2) {
            addCriterion("delivery_volume_weight not between", value1, value2, "deliveryVolumeWeight");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(Double value) {
            addCriterion("amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(Double value) {
            addCriterion("amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(Double value) {
            addCriterion("amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(Double value) {
            addCriterion("amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(Double value) {
            addCriterion("amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(Double value) {
            addCriterion("amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<Double> values) {
            addCriterion("amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<Double> values) {
            addCriterion("amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(Double value1, Double value2) {
            addCriterion("amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(Double value1, Double value2) {
            addCriterion("amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andMemoIsNull() {
            addCriterion("memo is null");
            return (Criteria) this;
        }

        public Criteria andMemoIsNotNull() {
            addCriterion("memo is not null");
            return (Criteria) this;
        }

        public Criteria andMemoEqualTo(String value) {
            addCriterion("memo =", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotEqualTo(String value) {
            addCriterion("memo <>", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThan(String value) {
            addCriterion("memo >", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThanOrEqualTo(String value) {
            addCriterion("memo >=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThan(String value) {
            addCriterion("memo <", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThanOrEqualTo(String value) {
            addCriterion("memo <=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLike(String value) {
            addCriterion("memo like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotLike(String value) {
            addCriterion("memo not like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoIn(List<String> values) {
            addCriterion("memo in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotIn(List<String> values) {
            addCriterion("memo not in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoBetween(String value1, String value2) {
            addCriterion("memo between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotBetween(String value1, String value2) {
            addCriterion("memo not between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andOutroomDateIsNull() {
            addCriterion("outroom_date is null");
            return (Criteria) this;
        }

        public Criteria andOutroomDateIsNotNull() {
            addCriterion("outroom_date is not null");
            return (Criteria) this;
        }

        public Criteria andOutroomDateEqualTo(Date value) {
            addCriterion("outroom_date =", value, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andOutroomDateNotEqualTo(Date value) {
            addCriterion("outroom_date <>", value, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andOutroomDateGreaterThan(Date value) {
            addCriterion("outroom_date >", value, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andOutroomDateGreaterThanOrEqualTo(Date value) {
            addCriterion("outroom_date >=", value, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andOutroomDateLessThan(Date value) {
            addCriterion("outroom_date <", value, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andOutroomDateLessThanOrEqualTo(Date value) {
            addCriterion("outroom_date <=", value, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andOutroomDateIn(List<Date> values) {
            addCriterion("outroom_date in", values, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andOutroomDateNotIn(List<Date> values) {
            addCriterion("outroom_date not in", values, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andOutroomDateBetween(Date value1, Date value2) {
            addCriterion("outroom_date between", value1, value2, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andOutroomDateNotBetween(Date value1, Date value2) {
            addCriterion("outroom_date not between", value1, value2, "outroomDate");
            return (Criteria) this;
        }

        public Criteria andCreateDtIsNull() {
            addCriterion("create_dt is null");
            return (Criteria) this;
        }

        public Criteria andCreateDtIsNotNull() {
            addCriterion("create_dt is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDtEqualTo(Date value) {
            addCriterion("create_dt =", value, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateDtNotEqualTo(Date value) {
            addCriterion("create_dt <>", value, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateDtGreaterThan(Date value) {
            addCriterion("create_dt >", value, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateDtGreaterThanOrEqualTo(Date value) {
            addCriterion("create_dt >=", value, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateDtLessThan(Date value) {
            addCriterion("create_dt <", value, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateDtLessThanOrEqualTo(Date value) {
            addCriterion("create_dt <=", value, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateDtIn(List<Date> values) {
            addCriterion("create_dt in", values, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateDtNotIn(List<Date> values) {
            addCriterion("create_dt not in", values, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateDtBetween(Date value1, Date value2) {
            addCriterion("create_dt between", value1, value2, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateDtNotBetween(Date value1, Date value2) {
            addCriterion("create_dt not between", value1, value2, "createDt");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(Integer value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(Integer value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(Integer value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(Integer value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(Integer value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(Integer value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<Integer> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<Integer> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(Integer value1, Integer value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(Integer value1, Integer value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtIsNull() {
            addCriterion("last_update_dt is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtIsNotNull() {
            addCriterion("last_update_dt is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtEqualTo(Date value) {
            addCriterion("last_update_dt =", value, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtNotEqualTo(Date value) {
            addCriterion("last_update_dt <>", value, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtGreaterThan(Date value) {
            addCriterion("last_update_dt >", value, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtGreaterThanOrEqualTo(Date value) {
            addCriterion("last_update_dt >=", value, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtLessThan(Date value) {
            addCriterion("last_update_dt <", value, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtLessThanOrEqualTo(Date value) {
            addCriterion("last_update_dt <=", value, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtIn(List<Date> values) {
            addCriterion("last_update_dt in", values, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtNotIn(List<Date> values) {
            addCriterion("last_update_dt not in", values, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtBetween(Date value1, Date value2) {
            addCriterion("last_update_dt between", value1, value2, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateDtNotBetween(Date value1, Date value2) {
            addCriterion("last_update_dt not between", value1, value2, "lastUpdateDt");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByIsNull() {
            addCriterion("last_update_by is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByIsNotNull() {
            addCriterion("last_update_by is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByEqualTo(Integer value) {
            addCriterion("last_update_by =", value, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByNotEqualTo(Integer value) {
            addCriterion("last_update_by <>", value, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByGreaterThan(Integer value) {
            addCriterion("last_update_by >", value, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByGreaterThanOrEqualTo(Integer value) {
            addCriterion("last_update_by >=", value, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByLessThan(Integer value) {
            addCriterion("last_update_by <", value, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByLessThanOrEqualTo(Integer value) {
            addCriterion("last_update_by <=", value, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByIn(List<Integer> values) {
            addCriterion("last_update_by in", values, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByNotIn(List<Integer> values) {
            addCriterion("last_update_by not in", values, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByBetween(Integer value1, Integer value2) {
            addCriterion("last_update_by between", value1, value2, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdateByNotBetween(Integer value1, Integer value2) {
            addCriterion("last_update_by not between", value1, value2, "lastUpdateBy");
            return (Criteria) this;
        }

        public Criteria andStsIsNull() {
            addCriterion("sts is null");
            return (Criteria) this;
        }

        public Criteria andStsIsNotNull() {
            addCriterion("sts is not null");
            return (Criteria) this;
        }

        public Criteria andStsEqualTo(String value) {
            addCriterion("sts =", value, "sts");
            return (Criteria) this;
        }

        public Criteria andStsNotEqualTo(String value) {
            addCriterion("sts <>", value, "sts");
            return (Criteria) this;
        }

        public Criteria andStsGreaterThan(String value) {
            addCriterion("sts >", value, "sts");
            return (Criteria) this;
        }

        public Criteria andStsGreaterThanOrEqualTo(String value) {
            addCriterion("sts >=", value, "sts");
            return (Criteria) this;
        }

        public Criteria andStsLessThan(String value) {
            addCriterion("sts <", value, "sts");
            return (Criteria) this;
        }

        public Criteria andStsLessThanOrEqualTo(String value) {
            addCriterion("sts <=", value, "sts");
            return (Criteria) this;
        }

        public Criteria andStsLike(String value) {
            addCriterion("sts like", value, "sts");
            return (Criteria) this;
        }

        public Criteria andStsNotLike(String value) {
            addCriterion("sts not like", value, "sts");
            return (Criteria) this;
        }

        public Criteria andStsIn(List<String> values) {
            addCriterion("sts in", values, "sts");
            return (Criteria) this;
        }

        public Criteria andStsNotIn(List<String> values) {
            addCriterion("sts not in", values, "sts");
            return (Criteria) this;
        }

        public Criteria andStsBetween(String value1, String value2) {
            addCriterion("sts between", value1, value2, "sts");
            return (Criteria) this;
        }

        public Criteria andStsNotBetween(String value1, String value2) {
            addCriterion("sts not between", value1, value2, "sts");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersIsNull() {
            addCriterion("doorplateNumbers is null");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersIsNotNull() {
            addCriterion("doorplateNumbers is not null");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersEqualTo(String value) {
            addCriterion("doorplateNumbers =", value, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersNotEqualTo(String value) {
            addCriterion("doorplateNumbers <>", value, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersGreaterThan(String value) {
            addCriterion("doorplateNumbers >", value, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersGreaterThanOrEqualTo(String value) {
            addCriterion("doorplateNumbers >=", value, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersLessThan(String value) {
            addCriterion("doorplateNumbers <", value, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersLessThanOrEqualTo(String value) {
            addCriterion("doorplateNumbers <=", value, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersLike(String value) {
            addCriterion("doorplateNumbers like", value, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersNotLike(String value) {
            addCriterion("doorplateNumbers not like", value, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersIn(List<String> values) {
            addCriterion("doorplateNumbers in", values, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersNotIn(List<String> values) {
            addCriterion("doorplateNumbers not in", values, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersBetween(String value1, String value2) {
            addCriterion("doorplateNumbers between", value1, value2, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersNotBetween(String value1, String value2) {
            addCriterion("doorplateNumbers not between", value1, value2, "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andEntIdIsNull() {
            addCriterion("ent_id is null");
            return (Criteria) this;
        }

        public Criteria andEntIdIsNotNull() {
            addCriterion("ent_id is not null");
            return (Criteria) this;
        }

        public Criteria andEntIdEqualTo(Integer value) {
            addCriterion("ent_id =", value, "entId");
            return (Criteria) this;
        }

        public Criteria andEntIdNotEqualTo(Integer value) {
            addCriterion("ent_id <>", value, "entId");
            return (Criteria) this;
        }

        public Criteria andEntIdGreaterThan(Integer value) {
            addCriterion("ent_id >", value, "entId");
            return (Criteria) this;
        }

        public Criteria andEntIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ent_id >=", value, "entId");
            return (Criteria) this;
        }

        public Criteria andEntIdLessThan(Integer value) {
            addCriterion("ent_id <", value, "entId");
            return (Criteria) this;
        }

        public Criteria andEntIdLessThanOrEqualTo(Integer value) {
            addCriterion("ent_id <=", value, "entId");
            return (Criteria) this;
        }

        public Criteria andEntIdIn(List<Integer> values) {
            addCriterion("ent_id in", values, "entId");
            return (Criteria) this;
        }

        public Criteria andEntIdNotIn(List<Integer> values) {
            addCriterion("ent_id not in", values, "entId");
            return (Criteria) this;
        }

        public Criteria andEntIdBetween(Integer value1, Integer value2) {
            addCriterion("ent_id between", value1, value2, "entId");
            return (Criteria) this;
        }

        public Criteria andEntIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ent_id not between", value1, value2, "entId");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameIsNull() {
            addCriterion("recipient_region_name is null");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameIsNotNull() {
            addCriterion("recipient_region_name is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameEqualTo(String value) {
            addCriterion("recipient_region_name =", value, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameNotEqualTo(String value) {
            addCriterion("recipient_region_name <>", value, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameGreaterThan(String value) {
            addCriterion("recipient_region_name >", value, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameGreaterThanOrEqualTo(String value) {
            addCriterion("recipient_region_name >=", value, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameLessThan(String value) {
            addCriterion("recipient_region_name <", value, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameLessThanOrEqualTo(String value) {
            addCriterion("recipient_region_name <=", value, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameLike(String value) {
            addCriterion("recipient_region_name like", value, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameNotLike(String value) {
            addCriterion("recipient_region_name not like", value, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameIn(List<String> values) {
            addCriterion("recipient_region_name in", values, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameNotIn(List<String> values) {
            addCriterion("recipient_region_name not in", values, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameBetween(String value1, String value2) {
            addCriterion("recipient_region_name between", value1, value2, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameNotBetween(String value1, String value2) {
            addCriterion("recipient_region_name not between", value1, value2, "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameIsNull() {
            addCriterion("recipient_city_name is null");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameIsNotNull() {
            addCriterion("recipient_city_name is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameEqualTo(String value) {
            addCriterion("recipient_city_name =", value, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameNotEqualTo(String value) {
            addCriterion("recipient_city_name <>", value, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameGreaterThan(String value) {
            addCriterion("recipient_city_name >", value, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameGreaterThanOrEqualTo(String value) {
            addCriterion("recipient_city_name >=", value, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameLessThan(String value) {
            addCriterion("recipient_city_name <", value, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameLessThanOrEqualTo(String value) {
            addCriterion("recipient_city_name <=", value, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameLike(String value) {
            addCriterion("recipient_city_name like", value, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameNotLike(String value) {
            addCriterion("recipient_city_name not like", value, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameIn(List<String> values) {
            addCriterion("recipient_city_name in", values, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameNotIn(List<String> values) {
            addCriterion("recipient_city_name not in", values, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameBetween(String value1, String value2) {
            addCriterion("recipient_city_name between", value1, value2, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameNotBetween(String value1, String value2) {
            addCriterion("recipient_city_name not between", value1, value2, "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNull() {
            addCriterion("shop_name is null");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNotNull() {
            addCriterion("shop_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopNameEqualTo(String value) {
            addCriterion("shop_name =", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotEqualTo(String value) {
            addCriterion("shop_name <>", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThan(String value) {
            addCriterion("shop_name >", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("shop_name >=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThan(String value) {
            addCriterion("shop_name <", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThanOrEqualTo(String value) {
            addCriterion("shop_name <=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLike(String value) {
            addCriterion("shop_name like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotLike(String value) {
            addCriterion("shop_name not like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameIn(List<String> values) {
            addCriterion("shop_name in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotIn(List<String> values) {
            addCriterion("shop_name not in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameBetween(String value1, String value2) {
            addCriterion("shop_name between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotBetween(String value1, String value2) {
            addCriterion("shop_name not between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andRefundFlagIsNull() {
            addCriterion("refund_flag is null");
            return (Criteria) this;
        }

        public Criteria andRefundFlagIsNotNull() {
            addCriterion("refund_flag is not null");
            return (Criteria) this;
        }

        public Criteria andRefundFlagEqualTo(String value) {
            addCriterion("refund_flag =", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagNotEqualTo(String value) {
            addCriterion("refund_flag <>", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagGreaterThan(String value) {
            addCriterion("refund_flag >", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagGreaterThanOrEqualTo(String value) {
            addCriterion("refund_flag >=", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagLessThan(String value) {
            addCriterion("refund_flag <", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagLessThanOrEqualTo(String value) {
            addCriterion("refund_flag <=", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagLike(String value) {
            addCriterion("refund_flag like", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagNotLike(String value) {
            addCriterion("refund_flag not like", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagIn(List<String> values) {
            addCriterion("refund_flag in", values, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagNotIn(List<String> values) {
            addCriterion("refund_flag not in", values, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagBetween(String value1, String value2) {
            addCriterion("refund_flag between", value1, value2, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagNotBetween(String value1, String value2) {
            addCriterion("refund_flag not between", value1, value2, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagIsNull() {
            addCriterion("print_flag is null");
            return (Criteria) this;
        }

        public Criteria andPrintFlagIsNotNull() {
            addCriterion("print_flag is not null");
            return (Criteria) this;
        }

        public Criteria andPrintFlagEqualTo(String value) {
            addCriterion("print_flag =", value, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagNotEqualTo(String value) {
            addCriterion("print_flag <>", value, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagGreaterThan(String value) {
            addCriterion("print_flag >", value, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagGreaterThanOrEqualTo(String value) {
            addCriterion("print_flag >=", value, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagLessThan(String value) {
            addCriterion("print_flag <", value, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagLessThanOrEqualTo(String value) {
            addCriterion("print_flag <=", value, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagLike(String value) {
            addCriterion("print_flag like", value, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagNotLike(String value) {
            addCriterion("print_flag not like", value, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagIn(List<String> values) {
            addCriterion("print_flag in", values, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagNotIn(List<String> values) {
            addCriterion("print_flag not in", values, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagBetween(String value1, String value2) {
            addCriterion("print_flag between", value1, value2, "printFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagNotBetween(String value1, String value2) {
            addCriterion("print_flag not between", value1, value2, "printFlag");
            return (Criteria) this;
        }

        public Criteria andBelongAreaIsNull() {
            addCriterion("belong_area is null");
            return (Criteria) this;
        }

        public Criteria andBelongAreaIsNotNull() {
            addCriterion("belong_area is not null");
            return (Criteria) this;
        }

        public Criteria andBelongAreaEqualTo(String value) {
            addCriterion("belong_area =", value, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaNotEqualTo(String value) {
            addCriterion("belong_area <>", value, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaGreaterThan(String value) {
            addCriterion("belong_area >", value, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaGreaterThanOrEqualTo(String value) {
            addCriterion("belong_area >=", value, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaLessThan(String value) {
            addCriterion("belong_area <", value, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaLessThanOrEqualTo(String value) {
            addCriterion("belong_area <=", value, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaLike(String value) {
            addCriterion("belong_area like", value, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaNotLike(String value) {
            addCriterion("belong_area not like", value, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaIn(List<String> values) {
            addCriterion("belong_area in", values, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaNotIn(List<String> values) {
            addCriterion("belong_area not in", values, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaBetween(String value1, String value2) {
            addCriterion("belong_area between", value1, value2, "belongArea");
            return (Criteria) this;
        }

        public Criteria andBelongAreaNotBetween(String value1, String value2) {
            addCriterion("belong_area not between", value1, value2, "belongArea");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2IsNull() {
            addCriterion("recipient_phone2 is null");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2IsNotNull() {
            addCriterion("recipient_phone2 is not null");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2EqualTo(String value) {
            addCriterion("recipient_phone2 =", value, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2NotEqualTo(String value) {
            addCriterion("recipient_phone2 <>", value, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2GreaterThan(String value) {
            addCriterion("recipient_phone2 >", value, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2GreaterThanOrEqualTo(String value) {
            addCriterion("recipient_phone2 >=", value, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2LessThan(String value) {
            addCriterion("recipient_phone2 <", value, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2LessThanOrEqualTo(String value) {
            addCriterion("recipient_phone2 <=", value, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2Like(String value) {
            addCriterion("recipient_phone2 like", value, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2NotLike(String value) {
            addCriterion("recipient_phone2 not like", value, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2In(List<String> values) {
            addCriterion("recipient_phone2 in", values, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2NotIn(List<String> values) {
            addCriterion("recipient_phone2 not in", values, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2Between(String value1, String value2) {
            addCriterion("recipient_phone2 between", value1, value2, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2NotBetween(String value1, String value2) {
            addCriterion("recipient_phone2 not between", value1, value2, "recipientPhone2");
            return (Criteria) this;
        }

        public Criteria andCommitDateIsNull() {
            addCriterion("commit_date is null");
            return (Criteria) this;
        }

        public Criteria andCommitDateIsNotNull() {
            addCriterion("commit_date is not null");
            return (Criteria) this;
        }

        public Criteria andCommitDateEqualTo(Date value) {
            addCriterion("commit_date =", value, "commitDate");
            return (Criteria) this;
        }

        public Criteria andCommitDateNotEqualTo(Date value) {
            addCriterion("commit_date <>", value, "commitDate");
            return (Criteria) this;
        }

        public Criteria andCommitDateGreaterThan(Date value) {
            addCriterion("commit_date >", value, "commitDate");
            return (Criteria) this;
        }

        public Criteria andCommitDateGreaterThanOrEqualTo(Date value) {
            addCriterion("commit_date >=", value, "commitDate");
            return (Criteria) this;
        }

        public Criteria andCommitDateLessThan(Date value) {
            addCriterion("commit_date <", value, "commitDate");
            return (Criteria) this;
        }

        public Criteria andCommitDateLessThanOrEqualTo(Date value) {
            addCriterion("commit_date <=", value, "commitDate");
            return (Criteria) this;
        }

        public Criteria andCommitDateIn(List<Date> values) {
            addCriterion("commit_date in", values, "commitDate");
            return (Criteria) this;
        }

        public Criteria andCommitDateNotIn(List<Date> values) {
            addCriterion("commit_date not in", values, "commitDate");
            return (Criteria) this;
        }

        public Criteria andCommitDateBetween(Date value1, Date value2) {
            addCriterion("commit_date between", value1, value2, "commitDate");
            return (Criteria) this;
        }

        public Criteria andCommitDateNotBetween(Date value1, Date value2) {
            addCriterion("commit_date not between", value1, value2, "commitDate");
            return (Criteria) this;
        }

        public Criteria andOrderNoLikeInsensitive(String value) {
            addCriterion("upper(order_no) like", value.toUpperCase(), "orderNo");
            return (Criteria) this;
        }

        public Criteria andStatusLikeInsensitive(String value) {
            addCriterion("upper(status) like", value.toUpperCase(), "status");
            return (Criteria) this;
        }

        public Criteria andRecipientNameLikeInsensitive(String value) {
            addCriterion("upper(recipient_name) like", value.toUpperCase(), "recipientName");
            return (Criteria) this;
        }

        public Criteria andRecipientPhoneLikeInsensitive(String value) {
            addCriterion("upper(recipient_phone) like", value.toUpperCase(), "recipientPhone");
            return (Criteria) this;
        }

        public Criteria andRecipientEmailLikeInsensitive(String value) {
            addCriterion("upper(recipient_email) like", value.toUpperCase(), "recipientEmail");
            return (Criteria) this;
        }

        public Criteria andRecipientZipcodeLikeInsensitive(String value) {
            addCriterion("upper(recipient_zipcode) like", value.toUpperCase(), "recipientZipcode");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress1LikeInsensitive(String value) {
            addCriterion("upper(recipient_address1) like", value.toUpperCase(), "recipientAddress1");
            return (Criteria) this;
        }

        public Criteria andRecipientAddress2LikeInsensitive(String value) {
            addCriterion("upper(recipient_address2) like", value.toUpperCase(), "recipientAddress2");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeLikeInsensitive(String value) {
            addCriterion("upper(delivery_code) like", value.toUpperCase(), "deliveryCode");
            return (Criteria) this;
        }

        public Criteria andDeliveryCodeFullLikeInsensitive(String value) {
            addCriterion("upper(delivery_code_full) like", value.toUpperCase(), "deliveryCodeFull");
            return (Criteria) this;
        }

        public Criteria andMemoLikeInsensitive(String value) {
            addCriterion("upper(memo) like", value.toUpperCase(), "memo");
            return (Criteria) this;
        }

        public Criteria andStsLikeInsensitive(String value) {
            addCriterion("upper(sts) like", value.toUpperCase(), "sts");
            return (Criteria) this;
        }

        public Criteria andDoorplatenumbersLikeInsensitive(String value) {
            addCriterion("upper(doorplateNumbers) like", value.toUpperCase(), "doorplatenumbers");
            return (Criteria) this;
        }

        public Criteria andRecipientRegionNameLikeInsensitive(String value) {
            addCriterion("upper(recipient_region_name) like", value.toUpperCase(), "recipientRegionName");
            return (Criteria) this;
        }

        public Criteria andRecipientCityNameLikeInsensitive(String value) {
            addCriterion("upper(recipient_city_name) like", value.toUpperCase(), "recipientCityName");
            return (Criteria) this;
        }

        public Criteria andShopNameLikeInsensitive(String value) {
            addCriterion("upper(shop_name) like", value.toUpperCase(), "shopName");
            return (Criteria) this;
        }

        public Criteria andRefundFlagLikeInsensitive(String value) {
            addCriterion("upper(refund_flag) like", value.toUpperCase(), "refundFlag");
            return (Criteria) this;
        }

        public Criteria andPrintFlagLikeInsensitive(String value) {
            addCriterion("upper(print_flag) like", value.toUpperCase(), "printFlag");
            return (Criteria) this;
        }

        public Criteria andBelongAreaLikeInsensitive(String value) {
            addCriterion("upper(belong_area) like", value.toUpperCase(), "belongArea");
            return (Criteria) this;
        }

        public Criteria andRecipientPhone2LikeInsensitive(String value) {
            addCriterion("upper(recipient_phone2) like", value.toUpperCase(), "recipientPhone2");
            return (Criteria) this;
        }
    }

    /**
     * crm_order_info
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class corresponds to the database table crm_order_info
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}